CDC for Microsoft SQL Server using Routes and Queues
Category |
|
Prerequisites |
|
Third-party software |
Microsoft SQL server with CDC |
Description
|
Talend offers several components for managing Change Data Capture (CDC) for a wide range of enterprise relational databases. To help companies manage the increasing necessity of making changes in real time (or near real time) it can be helpful to adopt a strategy based on Enterprise Service Bus (ESB) instead of the classical approach based on batch Jobs.
This solution template shows you how to implement a fully functional CDC framework for Microsoft SQL Server and dynamically push the incremental changes in a message queue, such as Active MQ. |